//¾Æ·¡ ºÎºÐÀº ´ÙÀ½ ½Åû¼ ¼öÁ¤À» ÇÒ ½Ã¿¡ »ç¿ëÇÔ
if($add_modify){
$sql1= "select * from $board
where code = '$code' and main_no=$main_no and dep_no='$dep_no' and add_no=$add_no
order by add_no desc, sub1 desc";
$result1 = mysql_query($sql1);
$row1 = mysql_fetch_array($result1);
}
//user Å×ÀÌºí¿¡¼ ¾ÆÀ̵ð¿Í °°Àº µ¥ÀÌŸ¸¦ ºÒ·¯¿Â´Ù.
if($id) {
$rsq2 = "select * from user where id='$id'";
$result2 = mysql_query($rsq2);
$row2 = mysql_fetch_array($result2);
$temp_pass=base64_encode($row2[password]);//ÆÐ½º¿öµå¸¦ ¾ÏÈ£ÈÇÑ´Ù.
$temp_resno=base64_encode($row2[resno]);//ÁֹιøÈ£¸¦ ¾ÏÈ£ÈÇÑ´Ù.
//½Åû¼ ÀÔ·ÂÆûÀÇ Ãâ·Â¿©ºÎ¸¦ °áÁ¤ÇϱâÀ§ÇØ ¾ÆÀ̵𸦠ºÒ¾î¿Â´Ù.
$sql3= "select id from $board
where code = '$code' and main_no=$main_no and dep_no='$dep_no' and add_no<>0 and id='$id'
order by id desc, sub1 desc";
$result3 = mysql_query($sql3);
$row3 = mysql_fetch_array($result3);
}
?>
//´ëȸ½ÅûÆûÀ» Á¶°Ç¿¡ ¸ÂÀ¸¸é ºÒ·¯¿Â´Ù. À̰ÍÀº ÀǰߴޱâÀÇ ÀÔ·ÂÆûÀ» ¼öÁ¤µµ °¡´ÉÇÏ°Ô È®ÀåÇÑ °ÍÀÌ´Ù.
if(strlen($id)>0 and $add_write==yes or strlen($add_modify)>0) include("./entry_form.html");
?>
//ÇÔ¼ö µî·Ï ºÎ ========================================================
function echo_line($no, $row) {
global $d_main, $d_dep, $code, $main_no, $dep_no, $my_color, $icon, $a_border, $al_color, $ag_color,$scroll_color,$a_cut,$id,
$check_box, $thread, $down_no, $no_no, $writer_no, $date_no, $view_no, $admin_email, $opinion_num, $new_list, $vote_no, $cafe_url,$board;
echo "\n";
//½ÅûÀÚ À̸§°ú ¾ÆÀ̵ðÃâ·Â
echo "$row[name]($row[id]) | \n";
//´Þ¸®±â Á¾¸ñ Ãâ·Â
$pos = strpos($row[sub1],"_");
$sub_1 = substr($row[sub1],0,$pos);
$int_1 = substr($row[sub1],$pos+1);
if($sub_1=="5km") $sub_1="$sub_1";
elseif($sub_1=="10km") $sub_1="$sub_1";
elseif($sub_1=="HALF") $sub_1="$sub_1";
elseif($sub_1=="FULL") $sub_1="$sub_1";
else $sub_1="$sub_1";
echo "$sub_1 | \n";
//½Åû Àοø Ãâ·Â
echo "$row[int_1] | \n";
//Ƽ¼ÅÃ÷ »çÀÌÁî Ãâ·Â
echo "$row[sub4] | \n";
//Âü°¡ºñ Ãâ·Â
$sub_2=$int_1*$row[int_1];
echo "$sub_2 | \n";
//Âü°¡ºñ ³³ºÎ ¿©ºÎ Ãâ·Â
if($row[sub3]==Yes) $sub_3="$row[sub3]";
else $sub_3="$row[sub3]";
echo "$sub_3 | \n";
// ½Åû ³¯Â¥
include('../../inc_file/list/new_list.php'); //»õ±Û Ãâ·Â ¿©ºÎ¿Í ÀÛ¼º³¯ÀÚ ¼û±â±â°¡ µé¾î ÀÖ´Ù.
echo "$row[sub5] | \n";
//¼öÁ¤¹öư Ãâ·Â
if($row[id]==$id) $mod_link="¼öÁ¤";
else $mod_link="¼öÁ¤";
echo "$mod_link | \n";
//»èÁ¦¹öư Ãâ·Â
echo " | \n";
echo "
\n";
return ($file_type);
}
// ========================================================ÇÔ¼ö µî·Ï ºÎ
//db·ÎºÎÅÍ µ¥ÀÌŸ¸¦ ºÒ·¯¿Í¼ °¡°øÃ³¸®
//°Ô½Ã¹° ¸ñ·Ï °¡Á®¿À±â
$sql= "select * from $board
where code = '$code' and main_no=$main_no and dep_no='$dep_no' and add_no<>0
order by sub1 desc, name, add_no desc";
$result = mysql_query($sql);
//Á¾¸ñº° Âü°¡ÀÚ¸¦ ±¸ÇϱâÀ§ÇØ º¯¼ö¸¦ resultº¯¼ö¸¦ Àá±ñ ÀÚ²å´Ù.
$res = $result;
$fi=0; $te=0; $ha=0; $fu=0; $g_1=0; $g_2=0;
while($ro = mysql_fetch_array($res))
{
if($ro[sub1]=="5km_$row[int_1]") $fi=$fi+$ro[int_1];
elseif($ro[sub1]=="10km_$row[int_2]") $te=$te+$ro[int_1];
elseif($ro[sub1]=="HALF_$row[int_3]") $ha=$ha+$ro[int_1];
elseif($ro[sub1]=="FULL_$row[int_4]") $fu=$fu+$ro[int_1];
elseif($ro[sub1]=="$row[sub7]Km_$row[int_5]") $g_1=$g_1+$ro[int_1];
elseif($ro[sub1]=="$row[sub8]Km_$row[int_6]") $g_2=$g_2+$ro[int_1];
}
$t_count=$fi+$te+$ha+$fu+$g_1+$g_2;
if($t_count>0) mysql_data_seek($res,0);
$colm ="";
//ÇÑȸ鿡 Ãâ·ÂÇÒ ÁÙ ¼ö
$rows = 20;
//ÇÑ È¸é¿¡ Ãâ·ÂÇÒ ÆäÀÌÁö ¼ö
$page_scale = $a_page;
// Àüü±Û ¸ñ·Ï ¼ö
$count = mysql_num_rows($result);
// ÇöÀç º¸¿©ÁÖ´Â ÆäÀÌÁö¹øÈ£
if (empty($page)) $page = 1;
// ÇöÀç ÆäÀÌÁö¿¡ µû¸¥ º¸¿©ÁÙ °Ô½Ã¹°ÀÇ Ã¹ À§Ä¡
$start=($page-1)*$rows;
// °á°ú Áß¿¡¼ ÇöÀç ÆäÀÌÁöÀÇ Ã¹¹øÂ° ·¹ÄÚµå¼ÂÀ¸·Î À̵¿ÇÑ´Ù.
if ($start > 1) mysql_data_seek($result,$start);
// ÃÑ ÆäÀÌÁö¼ö
$total = ceil(($count)/$rows);
//±Û ³»¿ë º¸±â Æû°ú ÆäÀÌÁö À̵¿ Æû
//include("../../inc_file/list/form.php");
?>
CELLSPACING=0 CELLPADDING==$cellped?> BORDER=0>
|